 BEGIN{FS="\t"}
{
    #$1:datetime; $2:applicationId; $3:appChannel; $4:channel; $5:typeId; $6:ip; $7:countryCode, $8:area; $9:uuid; $10:sdkVersion; $11:appVersion;
    kind="pospv";
    key=$1"|"$2"|"$4"|"$5"|"$6"|"$9
    if($6 != "127.0.0.1"){
	    if(key in pospv ){
	        pospv[key] += 1;
	    }else{
	        pospv[key] = 1;
	    }
	    date[key]=substr($1,1,10);
	    time[key]=substr($1,12,2);
	    applicationId[key]=$2;
	    appChannel[key]=$3;
	    channel[key]=$4;
	    typeId[key]=$5;
	    ip[key]=$6;
	    countryCode[key]=$7;
	    area[key]=$8;
	    uuid[key]=$9;
	    sdkVersion[key]=$10;
	    appVersion[key]=$11;
    }
}
END{
    for(i in pospv){
        printf("%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\n",date[i],time[i],applicationId[i],appChannel[i],channel[i],typeId[i],pospv[i],ip[i],countryCode[i],area[i],uuid[i],sdkVersion[i],appVersion[i]);
    }
}
